﻿CREATE PROCEDURE [dbo].[sp_Get_MailForDivision]
	@Id VARCHAR(10)
AS
	SELECT da.Email FROM dbo.Accounts a
	inner join dbo.DivisionAdmin da on a.DivisionNum = da.DivisionNum
	WHERE a.AccountID = @Id